﻿/*
后期部署脚本模板							
--------------------------------------------------------------------------------------
 此文件包含将附加到生成脚本中的 SQL 语句。		
 使用 SQLCMD 语法将文件包含到后期部署脚本中。			
 示例:      :r .\myfile.sql								
 使用 SQLCMD 语法引用后期部署脚本中的变量。		
 示例:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

insert into ETL_DtSerCategory ([Id], [Caption], [Description],[IsEnabled]) values('{D862B06A-6045-4162-AC5C-9F144039711F}','外部数据服务','', 1);
insert into ETL_DtSerCategory ([Id], [Caption], [Description],[IsEnabled]) values('{9AB56520-B2A9-4BCA-B85E-E19A3764B26D}','内部标准数据服务','', 1);

insert into ETL_DtSerType ([Id], [Caption],[Description], [IsEnabled], [CategoryId], [ProxyAssembly],[ProxyType],[ManagerAssembly],[ManagerType]) values ('{8D09625B-F618-45C3-81F1-65AD3DF3373A}', 'WebService','', 1, '{D862B06A-6045-4162-AC5C-9F144039711F}', 'CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.WSDataServiceProxy','CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.WSDtSerManager');
insert into ETL_DtSerType ([Id], [Caption],[Description], [IsEnabled], [CategoryId], [ProxyAssembly],[ProxyType],[ManagerAssembly],[ManagerType]) values ('{FBC88932-8500-4D98-B795-FF84AEB002C3}', 'SQLServer数据库','', 1, '{D862B06A-6045-4162-AC5C-9F144039711F}','CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.SQL.SQLDtSerProxy','CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.SQLDtSerManager');
insert into ETL_DtSerType ([Id], [Caption],[Description], [IsEnabled], [CategoryId], [ProxyAssembly],[ProxyType],[ManagerAssembly],[ManagerType]) values ('{872BAE09-6B32-4DBA-A1C9-B24AF3D79757}', 'Excel','', 1, '{D862B06A-6045-4162-AC5C-9F144039711F}','CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.ExcelDtSerProxy','CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.ExcelDtSerManager');
insert into ETL_DtSerType ([Id], [Caption],[Description], [IsEnabled], [CategoryId], [ProxyAssembly],[ProxyType],[ManagerAssembly],[ManagerType]) values
	 ('{C7E6E4CA-FC41-41E7-A693-201607A27B39}', 'Extension','外部扩展服务', 1, '{D862B06A-6045-4162-AC5C-9F144039711F}','CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.ExtDtSerProxy','CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.ExtDSDtSerManager');
-- oracle
insert into ETL_DtSerType ([Id], [Caption],[Description], [IsEnabled], [CategoryId], [ProxyAssembly],[ProxyType],[ManagerAssembly],[ManagerType]) values ('{9E009B1A-98B5-44C6-8D85-525D9A3952E9}', 'Oracle数据库','', 1, '{D862B06A-6045-4162-AC5C-9F144039711F}','CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.Oracle.OracleDtSerProxy','CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.Oracle.OracleDtSerManager');
-- mysql
insert into ETL_DtSerType ([Id], [Caption],[Description], [IsEnabled], [CategoryId], [ProxyAssembly],[ProxyType],[ManagerAssembly],[ManagerType]) values ('{1AD086AB-2428-48A3-A845-1B11EDE2C92A}', 'MySql数据库','', 1, '{D862B06A-6045-4162-AC5C-9F144039711F}','CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.MySql.MySqlDtSerProxy','CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.MySql.MySqlDtSerManager');


insert into ETL_DtSerType ([Id], [Caption],[Description], [IsEnabled], [CategoryId], [ProxyAssembly],[ProxyType],[ManagerAssembly],[ManagerType]) values ('{09F75019-CBEA-401A-80A4-47502C057302}', 'RawDataService','', 1, '{9AB56520-B2A9-4BCA-B85E-E19A3764B26D}','CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.RDSDtSerProxy','CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.RDSDtSerManager');
insert into ETL_DtSerType ([Id], [Caption],[Description], [IsEnabled], [CategoryId], [ProxyAssembly],[ProxyType],[ManagerAssembly],[ManagerType]) values ('{D75C0354-4F07-4C2D-80B5-055B3105401E}', 'DataService','', 1, '{9AB56520-B2A9-4BCA-B85E-E19A3764B26D}','CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.DSDtSerProxy','CPPEI.ETL.DSImplement','CPPEI.ETL.DSImplement.DSDtSerManager');